2016-09-13 - 28015 - Enhancement - BPC Enhancements #FinanceControlling
Enhancements
28015 - BPC Enhancements
Purpose
Need to enhance the BPC infocube.
Admin Info
Purpose
|
Need to enhance the BPC infocube with all the requested items from NEC
|
Requested By
|
Deborah Synderburn
|
Spec Created By
|
Naveen Gadde
|
Spec Created Date
|
09/29/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZBPC_PLAN
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
40
|
5
|
Unit test in QUA
|
40
|
6
|
Other activity
|
00
|
|
TOTAL
|
136
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Saravanan on 09/14/2016:
1. Is there a license consolidation written into the logic at all? There is definitely actual data for most company codes pulling into LI_E01 from our COPA load.
2. Can Retail PRO data be pulled for EMEA and Korea?
3. No customer segments going forward for North America.
4. No collection breakdown of seasons- everything is stock, custom, program - Same as above.
5. New customer "segments" for Mexico and potentially others- can the logic be written to pull customer group 8 instead of 9 for those who want it?
6. Categories for EMEA are going to all be "EMEA" in the future- needto change Material Group 5 - This is in process and should be done by end of week.
In Scope:
BPC inofcube
Out of Scope:
Other Sources
Solution Summary
1. Need to remove license consolidation logic in BPC Plan infocube & BEx Queries.
2. Need to remove customer segment logic for North America region.
3. Need to change the logic to fetch only the season consolidation object, the logic for collection breakdown of seasons needs to be removed.
4. Need to fetch Customer group 8 for Mexico/Japan regions and Customer group 9 for all other regions.
5. Need to make necessary changes to the BEx Queries.
6. Need to validate the data in BPD.
7. Need to unit test the changes in BPQ.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if license consolidation is removed from BPC infocube & BEx Queries.
|
License consolidation needs to be removed from BPC Plan infocube & BEx Queries.
|
2
|
Check if logic is modified to populate Cust.Gr 8 for Mexico & Japan, Cust.Grp9 for remaiining regions.
|
Logic should be updated as per the requirement.
|
3
|
Check if season consolidation is getting updated as per the logic.
|
Season consolidation should be updated without any collection breakdown.
|
Solution Details
1. Need to remove license consolidation ZBPC_LIC logic in BPC Plan ZBPC_PLAN infocube & BEx Queries.
2. Need to remove customer segment 0BA_1SEGID logic only for North America region.
3. Need to change the logic to fetch only the season consolidation object, the logic for collection breakdown of seasons needs to be removed.
4. Need to fetch Customer group 8 ZCUST_GR8 for mexico & Japan regions and Customer group 9 ZCUST_GR9 for all other regions.
5. Need to make necessary changes to the BEx Queries based on BPC source.
6. Need to validate the data in BPD & BPQ.
Issues
1. During the data loading, users will not be able to see the data for budget values in reports.
2. Since the logic is getting complex to restrict the customer segment only for North America region, this logic needs to be implemented at report level.